Tabela ContractServiceRestriction

Definicja tabeli ContractServiceRestriction

Name

ContractServiceRestriction

Code

ContractServiceRestriction

Comment

Tabela restrykcji swiadczen


Lista kolumn tabeli ContractServiceRestriction

Name

Code

ContractServiceRestrictionID

ContractServiceRestrictionID

Sex

Sex

AgeToCalculationMethodID

AgeToCalculationMethodID

AgeFromCalculationMethodID

AgeFromCalculationMethodID

AgeTo

AgeTo

AgeFrom

AgeFrom

HospitalizationMode

HospitalizationMode

ToStatisticReport

ToStatisticReport

TreatmentSchemaRequired

TreatmentSchemaRequired

OneDayContractService

OneDayContractService

ICD9Required

ICD9Required

NFZConfirmation

NFZConfirmation

PerformingLocation

PerformingLocation

POZSchoolType

POZSchoolType

POZListKind

POZListKind

DPS

DPS

CatalogueCode

CatalogueCode


Kolumna ContractServiceRestrictionID tabeli ContractServiceRestriction

Definicja kolumny ContractServiceRestrictionID tabeli ContractServiceRestriction

Name

ContractServiceRestrictionID

Code

ContractServiceRestrictionID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna Sex tabeli ContractServiceRestriction

Definicja kolumny Sex tabeli ContractServiceRestriction

Name

Sex

Code

Sex

Data Type

VARCHAR2(1)

Mandatory

No

Comment

PL: Plec
EN: Sex of the person
DE: das Geschlecht


Kolumna AgeToCalculationMethodID tabeli ContractServiceRestriction

Definicja kolumny AgeToCalculationMethodID tabeli ContractServiceRestriction

Name

AgeToCalculationMethodID

Code

AgeToCalculationMethodID

Data Type

VARCHAR2(1)

Mandatory

No

Comment

 


Kolumna AgeFromCalculationMethodID tabeli ContractServiceRestriction

Definicja kolumny AgeFromCalculationMethodID tabeli ContractServiceRestriction

Name

AgeFromCalculationMethodID

Code

AgeFromCalculationMethodID

Data Type

VARCHAR2(1)

Mandatory

No

Comment

 


Kolumna AgeTo tabeli ContractServiceRestriction

Definicja kolumny AgeTo tabeli ContractServiceRestriction

Name

AgeTo

Code

AgeTo

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna AgeFrom tabeli ContractServiceRestriction

Definicja kolumny AgeFrom tabeli ContractServiceRestriction

Name

AgeFrom

Code

AgeFrom

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna HospitalizationMode tabeli ContractServiceRestriction

Definicja kolumny HospitalizationMode tabeli ContractServiceRestriction

Name

HospitalizationMode

Code

HospitalizationMode

Data Type

VARCHAR2(1)

Mandatory

No

Comment

 


Kolumna ToStatisticReport tabeli ContractServiceRestriction

Definicja kolumny ToStatisticReport tabeli ContractServiceRestriction

Name

ToStatisticReport

Code

ToStatisticReport

Data Type

VARCHAR2(1)

Mandatory

No

Comment

 


Kolumna TreatmentSchemaRequired tabeli ContractServiceRestriction

Definicja kolumny TreatmentSchemaRequired tabeli ContractServiceRestriction

Name

TreatmentSchemaRequired

Code

TreatmentSchemaRequired

Data Type

VARCHAR2(1)

Mandatory

No

Comment

 


Kolumna OneDayContractService tabeli ContractServiceRestriction

Definicja kolumny OneDayContractService tabeli ContractServiceRestriction

Name

OneDayContractService

Code

OneDayContractService

Data Type

VARCHAR2(1)

Mandatory

No

Comment

 


Kolumna ICD9Required tabeli ContractServiceRestriction

Definicja kolumny ICD9Required tabeli ContractServiceRestriction

Name

ICD9Required

Code

ICD9Required

Data Type

VARCHAR2(1)

Mandatory

No

Comment

 


Kolumna NFZConfirmation tabeli ContractServiceRestriction

Definicja kolumny NFZConfirmation tabeli ContractServiceRestriction

Name

NFZConfirmation

Code

NFZConfirmation

Data Type

VARCHAR2(1)

Mandatory

No

Comment

 


Kolumna PerformingLocation tabeli ContractServiceRestriction

Definicja kolumny PerformingLocation tabeli ContractServiceRestriction

Name

PerformingLocation

Code

PerformingLocation

Data Type

VARCHAR2(1)

Mandatory

No

Comment

 


Kolumna POZSchoolType tabeli ContractServiceRestriction

Definicja kolumny POZSchoolType tabeli ContractServiceRestriction

Name

POZSchoolType

Code

POZSchoolType

Data Type

VARCHAR2(1)

Mandatory

No

Comment

 


Kolumna POZListKind tabeli ContractServiceRestriction

Definicja kolumny POZListKind tabeli ContractServiceRestriction

Name

POZListKind

Code

POZListKind

Data Type

VARCHAR2(1)

Mandatory

No

Comment

 


Kolumna DPS tabeli ContractServiceRestriction

Definicja kolumny DPS tabeli ContractServiceRestriction

Name

DPS

Code

DPS

Data Type

VARCHAR2(1)

Mandatory

No

Comment

 


Kolumna CatalogueCode tabeli ContractServiceRestriction

Definicja kolumny CatalogueCode tabeli ContractServiceRestriction

Name

CatalogueCode

Code

CatalogueCode

Data Type

VARCHAR2(2)

Mandatory

No

Comment

 


Lista kluczy tabeli ContractServiceRestriction

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli ContractServiceRestriction

Definicja klucza Identifier_1 tabeli ContractServiceRestriction

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment